insert overwrite table jms_dim.dim_lmdm_sys_network_delivery_r
select
id
,country_id
,province_id
,city_id
,area_id
,zip_code
,network_id
,network_code
,network_name
,business_principal
,customer_service_principal
,business_telephone
,customer_service_telephone
,is_dispatch
,is_receiving
,start_business_time
,end_business_time
,address
,longitude
,latitude
,is_visibility
,is_enable
,is_delete
,create_by
,update_by
,create_by_name
,update_by_name
,create_time
,update_time
,version
,sort
,last_update_time_sync
,delivery_range
,receiving_range
,non_dr_range
,place_name
,dispatch_contact
,dispatch_contact_mobile
,sign_addr_range
from jms_ods.yl_lmdm_sys_network_delivery_r where dt= '{{ execution_date | cst_ds }}'
 distribute by 1 ;